create external table jms_ods.ep_settlement_rules_detail
(
    id      bigint comment 'id',
    price           bigint comment '单价',
    price_num_start bigint comment '计件量开始',
    price_num_end   bigint comment '计件量结束',
    unit_price_id   bigint comment '计件单价主表id',
    row_num         int comment '索引列'
)
comment '结算规则明细'
PARTITIONED BY (
  `dt` string COMMENT '时间分区')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/dw/hive/jms_ods.db/external/ep_settlement_rules_detail';